

<color><param>0100,0100,0100</param>Hi there 


<bold>I have a relatively simple problem :  </bold> 


I have a field named "id" that has type "Auto-number" in an Access 
database  table.   


When I export the database via ODBC to a PostgreSQL table, the 
"auto- number" property of this field is lost (!) :  

<<snippet of commlog> 

CREATE TABLE "names"("id" int4,"name" varchar(50),"tel_no" 
varchar(50)) 

<</snippet> 


I also access the PostgreSQL database via a web-based GUI 
(phpPgAdmin  from GreatBridge), and when I add new rows to it, 
the id field does not auto- increment. 


<bold><color><param>0000,0000,0000</param>This is my system : </bold> 


odbc driver version (on Win machine) : 7.01.00.04 Insight Distrib.  
(PSQLODBC.DLL) 


odbc driver version (on Red Hat machine) : postgresql-odbc-7.0.2-
17.rpm 


postgre database version : postgresql-7.0.2.rpm 


error messages on screen : none. 


the commlog file : see attached file (psqlodbc.log) 



<color><param>0100,0100,0100</param>Suggestions, workarounds and prayers would be appreciated ! 


love 

rich handler 




------- End of forwarded message -------

<nofill>

Rich Handler
OgilvyInteractive
18 Roeland St, Gardens, 8001, Cape Town
Fon 021 467 1402
Fax 021 467 1401
http://www.oi.co.za/



